Project Overview
row
Project Statement
For this project, we wanted to better understand the importance of internships in college. Specifically, we used the FSB Student Survey from 2019-2021 to answer the following questions:
If you have at least one internship, how much more likely are you to have a full-time job than if you did not have an internship?
What if you have two internships?
Does having an internship mean your salary level will be higher in your full-time job?
Before diving into the data, we created a business value proposition (see below) to better understand our customer’s pain points and the potential gain creators we can make.
Business Value Proposition
row
Insights
After analyzing our data, we found answers to each of the three questions above:
Looking at the tab titled “Internships to Full-Time Jobs”, the graph of “Percentage of Students with Full-Time Jobs by Number of Internships” shows that 57.69% of students who had 0 internships got full-time jobs post graduation, while 83.04% of students who had 1 internship got a full-time job. We can also see that students with 2, 3, 4, and 5 internships all had full-time job percentages much higher than students with 0 internships.
Looking at the tab titled “Internships to Full-Time Jobs”, the graph of “Percentage of Students with Full-Time Jobs by Number of Internships” shows that 83.04% of people who had 1 internship got a full-time job post graduation, while 89.31% of students with 2 internships got a full-time job post graduation.
Looking at the tab titled “Internships to Full-Time Jobs”, the graph of “Internship to Salary Impact” shows that there is a ~$5,000 difference in starting salary between students who had one internship vs. students who had zero internships.
Description of Deliverables
row
Survey Overview Section
In this tab of our analysis, we have included 4 different visualizations that we believe are important for our client. This section is intended to serve as an overview of the data and to give our client a brief, but easily understandable view of the student’s responses. Below, we have explained each of the 4 visualizations in-depth:
Response Rate: This is a graphic that shows the percentage of graduating students from 2019-2021 that responded to the FSB Internship & Full-Time Placement survey. It is important to see this percentage in order for the client to understand what percentage of students responded to the survey and that there might be missing responses.
Usable Responses: This is the number of responses we had available to use in our analysis. It is important for the client to get this background before diving into the graphics so they have a better understanding of how many students’ answers were taken into account in this analysis.
Internship Breakdown: This is a bar chart that shows the amount of students compared with the number of internships they had during their college career. This is a great breakdown to show the client so they better understand any skew in the amount of internships had by students in FSB. They can also see how many students had no internships vs. 1+ internships in FSB during their college career.
Post-Graduation Plans: This is a bar chart that shows different post-graduation plans the number of students pursing each option. It is important for our client to get an overview of what FSB students are doing after graduation as this could help them understand what paths FSB students may be interested in in the future.
Internships to Full-Time Jobs Section
The Internships to Full-Time section of our analysis contains deliverables that directly answer our original project questions. Below, we have developed descriptions of each deliverable:
Number of Internships to Full-Time: This is an interactive bar chart that shows the number of internships (0-5) on the x-axis and number of responses on the y-axis with the fill of the graph being full-time job placement (“yes” or “no”). There are a lot of insights to be derived from this graph. This graph is important to show a visual representation of the amount of students who landed full-time jobs vs. those who did not in each internship amount category.
Internship to Salary Impact: This is a bar chart that shows the average full-time job salary of students who had 0 internships in college and students who had at least 1 internship in college. This is important for the client when trying to answer question #3 on the “Project Overview” tab asking if a student’s salary will be higher if they had internships in college vs. if they did not.
Percentage of Students with Full-Time Jobs by Number of Internships: This is a bar chart that shows the percentage of students who landed full-time jobs in each internship amount category. This graph directly answers questions 1 and 2 from the “Project Overview” tab asking about the likelihood of a student landing a full-time job if they had internships in college vs. not having an internship.
Survey Overview
Overview of survey responses